Analysis Tools One of the newest tools in Excel is the Slicer. The Slicer can be found on the Analyze Ribbon as part of the PivotChart Tools. We'll start with the options for the Active Field and then work with the Slicer.   Before You Begin: The PivotChart is still on Sheet 1 with the PivotTable. The PivotChart is selected. The PivotChart Tools are available. The Chart Legend is on. The Data Table is turned off.   1. Try it: Review the Analyze Groups The Analyze groups include: PivotChart Active Field Filter Data Actions Calculations and Show/Hide.   Keep going... PivotChart Tools ->Analyze